<?php
$agencyId=getAgencyId();

$where="FROM immo_gallery gallery, immo_goods goods, portal_quartier quartier, portal_cities cities, immo_operationtype operationtype  WHERE  goods.operationtypeId = operationtype.id and  goods.id = gallery.goodId and quartier.id = goods.quartierId and cities.id = goods.cityId and  gallery.showHome = 'Y' and goods.agencyId=".$agencyId." and goods.showHome='Y' Order By goods.id Limit 0,4";

$sSql= "Select quartier.lib_".$lt." As quartier,  cities.lib_".$lt." As city,  goods.*,  gallery.picture, operationtype.lib_".$lang." As operation ".$where;
Portal_log($sSql);
      $rs=$GLOBALS["conn"]->Execute($sSql);
	  ?>
<div class="activities"> <div class="announcementsTitle"><?php echo $text_special_goods; ?></div> 

<table width="200" cellspacing="0px" cellpadding="11px" border="0" class="special"> <tbody>
<tr> <td style="padding-top: 15px; padding-<?php echo $left; ?>: 10px;"> <table width="178px" border="0"> <tbody>

	  <?php
 while ( !$rs->EOF)  { 
		  ?>
	
	<tr>
 <td class="rtd"> 
 <div class="date"><?php echo $rs->fields["operation"]; ?></div>
 
 <a href="<?php echo createUrl("goodId",$rs->fields["id"],"pageName","accueil"); ?>" > 

<div class="title"><?php echo $rs->fields["city"]; ?> / <?php echo $rs->fields["quartier"]; ?></div> 
<div class="description">


<img class="image" src = "/immo/pictures/<?php echo $rs->fields["picture"]; ?>"  height = "120px" width="170px"/>

<br/>
<?php echo $rs->fields["price"]; ?> <?php echo $text_dhs; ?> / <?php echo $rs->fields["price"]*11; ?> â‚¬ (<?php echo $text_around; ?>)	
 </div> </a> 
 </td> </tr> <tr height="16px"> <td></td>
 </tr> 
 
 
	
	
	
	
	
	
	
	
	
	
		  



				  <?php
		  $rs->MoveNext();    
		  }
		  


	
?>
 </tbody></table> </td> </tr> 
 <tr style=" height: 40px;"> 
 <td valign="bottom" background="" style="background-repeat: no-repeat; "> 
  </td> </tr> </tbody></table> </div>